package org.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.vo.Course;
import org.vo.Score;
import org.vo.Student;

public class ScoreJdbc {
	private Connection conn=null;
	private ResultSet rs=null;
	private PreparedStatement psmt=null;
	public ScoreJdbc() {
	}
	public Connection getConn() {
		try {
			if (this.conn==null || this.conn.isClosed()) {
				DBConn mc=new DBConn();
				this.conn=mc.getConn();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	public List<Course> sowCourse(){
		return null;
	}
	public List<Student> showStudent(){
		return null;
	}
	public Score addScore(Score socre) {
		return null;
	}
	

}
